ODBCexecSQL | OLE2call |
Syntax: @ODBCgetResult Connection_Handle, Out_of_data, Variable [, Variable]
This command retrieves one record from the current result table.
Connection Handle: This is the Connection handle returned from a previous use of the @ODBCconnect command.
Out of data: This is a numeric variable used as a true/false indicator to report if there was data available for the request. A returned value of 0 means that there was no more data.
Variable: An XpertRule variable(s) of any type for retrieving the relevant field(s).
Example
@ODBCgetResult ConnectionNo, ValidData, NameStr, Age